﻿<?xml version="1.0" encoding="utf-8"?>
<ScintillaNET>
	<Language Name="sql">
		<Lexer LineCommentPrefix="--" StreamCommentPrefix="/* " StreamCommentSuffix=" /*" >
			<Properties>
				<Property Name="fold.comment" Value="1" />
			</Properties>
			<!--Keywords -->
			<Keywords List="0">
				absolute action add admin after aggregate alias all allocate alter and any are array as asc assertion at authid authorization avg
				before begin between binary binary_integer bit blob body boolean both breadth bulk by
				call cascade cascaded case cast catalog char char_base character check class clob close cluster collate collation collect column comment commit completion compress connect connection constant constraint constraints constructor continue corresponding create cross cube current current_date current_path current_role current_time current_timestamp current_user currval cursor cycle
				data date day deallocate dec decimal declare default deferrable deferred delete depth deref desc describe descriptor destroy destructor deterministic diagnostics dictionary disconnect distinct do domain double drop dynamic
				each else elsif end end-exec equals escape every except exception exclusive exec execute exists exit extends external
				false fetch first float for forall foreign found free from full function
				general get global go goto grant group grouping
				having heap host hour
				identity if ignore immediate in index indicator initialize initially inner inout input insert int integer interface intersect interval into is isolation iterate
				java join
				key
				language large last lateral leading left less level like limit limited local localtime localtimestamp locator lock long loop
				map match max merge min minus minute mlslabel mod mode modifies modify module month
				names national natural naturaln nchar nclob new next nextval no nocopy none not nowait null number number_base numeric
				object ocirowid of off old on only opaque open operation operator option or order ordinality organization others out outer output
				package pad parameter parameters partial partition path pctfree pls_integer positive positiven postfix pragma precision prefix preorder prepare preserve primary prior private privileges procedure public
				raise range raw read reads real record recursive ref references referencing relative release restrict result return returns reverse revoke right role rollback rollup routine row rowid rownum rows rowtype
				savepoint schema scope scroll search second section select separate sequence session session_user set sets share size smallint some| space specific specifictype sql sqlcode sqlerrm sqlexception sqlstate sqlwarning start state statement static stddev structure subtype successful sum synonym sysdate system_user
				table temporary terminate than then time timestamp timezone_hour timezone_minute to trailing transaction translation treat trigger true type
				uid under union unique unknown unnest update usage use user using
				validate value values varchar varchar2 variable variance varying view
				when whenever where while with without work write
				year
				zone
			</Keywords>
			<!--PLDoc-->
			<Keywords List="1">
				author deprecated param return see since todo
			</Keywords>

			<!--SQL*Plus-->
			<Keywords List="2">
				a~ppend acc~ept archive attribute
				bre~ak bti~tle
				c~hange cl~ear col~umn comp~ute conn~ect copy
				def~ine del desc~ribe disc~onnect
				e~dit exec~ute exit
				get
				help ho~st
				i~nput
				l~ist log
				oserror
				passw~ord pau~se pri~nt pro~mpt
				quit
				r~un recover rem~ark repf~ooter reph~eader
				sav~e set sho~w shutdown spo~ol sqlerror sta~rt startup store
				timi~ng tti~tle
				undef~ine
				var~iable
				whenever
			</Keywords>

			<!--User Keywords 1-->
			<Keywords List="3">
				dbms_output.disable dbms_output.enable dbms_output.get_line dbms_output.get_lines dbms_output.new_line dbms_output.put dbms_output.put_line
			</Keywords>

			<!--User Keywords 2-->
			<Keywords List="4">
				abs cbrt ceil ceiling degrees exp floor ln log mod pi power radians random round setseed sign sqrt
				trunc width_bucket acos asin atan atan2 cos cot sin tan bit_length char_length character_length
				convert lower octet_length overlay position substring trim upper ascii btrim chr decode encode
				initcap length lpad ltrim md5 pg_client_encoding quote_ident quote_literal replace rpad rtrim
				split_part strpos substr to_ascii to_hex translate get_byte set_byte get_bit set_bit to_char
				to_date to_timestamp to_number age date_part date_trunc extract now timeofday isfinite
				area box_intersect center diameter height isclosed isopen npoints pclose popen radius
				width broadcast host masklen set_masklen netmask hostmask network abbrev family nextval
				currval setval coalesce nullif array_cat array_append array_prepend array_dims array_lower
				array_upper array_to_string string_to_array avg bit_and bit_or bool_and bool_or count
				every max min stddev sum variance exists in some all generate_series current_database
				current_schema current_schemas inet_client_addr inet_client_port inet_server_addr
				inet_server_port version has_table_privilege has_database_privilege has_function_privilege
				has_language_privilege has_schema_privilege has_tablespace_privilege pg_table_is_visible
				pg_type_is_visible pg_function_is_visible pg_operator_is_visible pg_opclass_is_visible
				pg_conversion_is_visible format_type pg_get_viewdef pg_get_ruledef pg_get_indexdef
				pg_get_triggerdef pg_get_constraintdef pg_get_expr pg_get_userbyid pg_get_serial_sequence
				pg_tablespace_databases obj_description col_description current_setting set_config
				pg_cancel_backend pg_start_backup pg_stop_backup current_user current_date current_time
				current_timestamp localtime localtimestamp session_user user
			</Keywords>

		</Lexer>
		<Styles>

			<Style Name="DOCUMENT_DEFAULT"/>
			<Style Name="WORD"	ForeColor="blue" bold="true" />
			<Style Name="WORD2"	ForeColor="teal" bold="true" />
			<Style Name="SQLPLUS"	ForeColor="red" bold="true" italic="true" />
			<Style Name="USER1"	ForeColor="#FFA36B" bold="true"/>
			<Style Name="USER2"	ForeColor="purple" bold ="true" />

			<!--Comments,operators etc  -->
			<Style Name="QUOTEDIDENTIFIER"	ForeColor="blue" />
			<Style Name="STRING"	ForeColor="blue" />
			<Style Name="OPERATOR"	ForeColor="#ff00ff" />
			<Style Name="NUMBER"	ForeColor="#ff00ff" bold="true" />
			<Style Name="COMMENTLINE"	ForeColor="green" bold="true" italic="true" />
			<Style Name="COMMENTDOC"	ForeColor="green" bold="true" italic="true" />
			<Style Name="COMMENT"	ForeColor="green" bold="true" italic="true" />
		</Styles>
	</Language>
</ScintillaNET>

